89

89

DOI: 10.1201/9781003214335-7

Merging Sheets

Combine Multiple

Workbooks of the Same

Format into One Workbook

Automatically

Spreadsheets are great to enforce a template.

If you are requesting data from a diverse group of people, and you are interested in

knowing and perhaps analyzing the data they provide, you must ensure that the items

they provide are uniform. Otherwise, you spend a whole lot of time sifting through

their records and figuring out how to stack everything up.

Here is an example.

You are working on a survey where you really want to know the number of shoes

sold in the last month for 100 stores by color, size, and type. So you distribute a

survey and ask each store to fill them out. You include a format as below to ensure

uniformity:

STORE

TYPE

COLOR

SIZE

NUMBER SOLD

Soon you have a 100 entries in your email box. Assuming that no one slacked off,

you have the data from 100 stores perfectly formatted, which looked like this for the

first Street Store:

STORE

TYPE

COLOR

SIZE

NUMBER SOLD

First Street

Goofey

red

S

300

First Street

Goofey

blue

M

100

First Street

Goofey

green

L

200

First Street

Goofey

black

S

300

First Street

Goofey

navy

M

100

6